CREATE DATABASE highscores;
USE highscores;
CREATE TABLE highscores (id SMALLINT 
UNSIGNED NULL AUTO_INCREMENT PRIMARY KEY, 
name VARCHAR( 30 ) CHARACTER SET latin1 
COLLATE latin1_swedish_ci NOT NULL, 
kills INT( 11 ) NOT NULL,
deaths INT( 11 ) NOT NULL);
